Overview

Dataset info

Number of variables27
Number of observations904719
Missing cells1718409 (7.0%)
Duplicate rows0 (0.0%)
Total size in memory180.3 MiB
Average record size in memory209.0 B

Variables types

Numeric3
Categorical20
Boolean1
Date0
URL0
Text (Unique)0
Rejected3
Unsupported0

Warnings

AGE_AT_INCIDENT has 17557 (1.9%) missing values Missing
AOIC has a high cardinality: 2331 distinct values Warning
ARRAIGNMENT_DATE has a high cardinality: 2473 distinct values Warning
ARRAIGNMENT_DATE has 127086 (14.0%) missing values Missing
ARREST_DATE has a high cardinality: 269479 distinct values Warning
ARREST_DATE has 30683 (3.4%) missing values Missing
CASE_PARTICIPANT_ID is highly correlated with CASE_ID (ρ = 0.9997263254) Rejected
CHARGE_ID is highly correlated with CASE_PARTICIPANT_ID (ρ = 0.9922534959) Rejected
CHARGE_OFFENSE_TITLE has a high cardinality: 1402 distinct values Warning
CHARGE_VERSION_ID is highly correlated with CHARGE_ID (ρ = 0.9999812286) Rejected
EVENT has 21355 (2.4%) missing values Missing
EVENT_DATE has a high cardinality: 2577 distinct values Warning
EVENT_DATE has 21355 (2.4%) missing values Missing
INCIDENT_BEGIN_DATE has a high cardinality: 4505 distinct values Warning
INCIDENT_BEGIN_DATE has 11553 (1.3%) missing values Missing
INCIDENT_CITY has a high cardinality: 273 distinct values Warning
INCIDENT_CITY has 34905 (3.9%) missing values Missing
INCIDENT_END_DATE has a high cardinality: 3792 distinct values Warning
INCIDENT_END_DATE has 806298 (89.1%) missing values Missing
LAW_ENFORCEMENT_AGENCY has a high cardinality: 303 distinct values Warning
OFFENSE_CATEGORY has a high cardinality: 87 distinct values Warning
RECEIVED_DATE only contains datetime values, but is categorical. Consider applying pd.to_datetime()Type
RECEIVED_DATE has a high cardinality: 3258 distinct values Warning
SECTION has a high cardinality: 1392 distinct values Warning
UNIT has a high cardinality: 98 distinct values Warning
UNIT has 633918 (70.1%) missing values Missing
UPDATED_OFFENSE_CATEGORY has a high cardinality: 81 distinct values Warning

Variables

ACT
Categorical

Distinct count49
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)8
5
692043
570
171596
550
 
25975
Other values (45)
 
15097
ValueCountFrequency (%) 
5 692043 76.5%
 
570 171596 19.0%
 
550 25975 2.9%
 
150 4325 0.5%
 
335 2428 0.3%
 
65 2330 0.3%
 
646 2016 0.2%
 
250 1002 0.1%
 
120 722 0.1%
 
154 543 0.1%
 
Other values (38) 1731 0.2%
 
Max length4
Mean length1.466991408
Min length1
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

AGE_AT_INCIDENT
Numeric

Distinct count91
Unique (%)< 0.1%
Missing (%)1.9%
Missing (n)17557
Infinite (%)0.0%
Infinite (n)0
Mean31.9861908
Minimum17
Maximum156
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum17
5-th percentile18
Q122
Median29
Q339
95-th percentile55
Maximum156
Range139
Interquartile range17

Descriptive statistics

Standard deviation11.72911547
Coef of variation0.3666931002
Kurtosis0.2151181959
Mean31.9861908
MAD9.613647886
Skewness0.9101415011
Sum28376933
Variance137.5721496
Memory size6.9 MiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
19 47329 5.2%
 
20 47322 5.2%
 
21 42632 4.7%
 
22 40684 4.5%
 
23 40422 4.5%
 
24 38527 4.3%
 
25 34601 3.8%
 
26 33841 3.7%
 
18 33089 3.7%
 
27 31721 3.5%
 
Other values (80) 496994 54.9%
 

Minimum 5 values

ValueCountFrequency (%) 
17 12569 1.4%
 
18 33089 3.7%
 
19 47329 5.2%
 
20 47322 5.2%
 
21 42632 4.7%
 

Maximum 5 values

ValueCountFrequency (%) 
156 1 < 0.1%
 
137 2 < 0.1%
 
130 1 < 0.1%
 
127 2 < 0.1%
 
125 1 < 0.1%
 

AOIC
Categorical

Distinct count2331
Unique (%)0.3%
Missing (%)0.0%
Missing (n)0
5101110
 
94941
0012476
 
28227
0735000
 
28069
Other values (2328)
753482
ValueCountFrequency (%) 
5101110 94941 10.5%
 
0012476 28227 3.1%
 
0735000 28069 3.1%
 
0014717 24369 2.7%
 
0016108 23707 2.6%
 
0012309 22459 2.5%
 
5097200 20628 2.3%
 
0014716 17895 2.0%
 
0014056 17677 2.0%
 
0012474 16332 1.8%
 
Other values (2321) 610415 67.5%
 
Max length10
Mean length7.000704086
Min length6
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

ARRAIGNMENT_DATE
Categorical

Distinct count2473
Unique (%)0.3%
Missing (%)14.0%
Missing (n)127086
6/28/2016 12:00:00 AM
 
1615
2/3/2015 12:00:00 AM
 
1005
3/20/2014 12:00:00 AM
 
987
Other values (2469)
774026
(Missing)
 
127086
ValueCountFrequency (%) 
6/28/2016 12:00:00 AM 1615 0.2%
 
2/3/2015 12:00:00 AM 1005 0.1%
 
3/20/2014 12:00:00 AM 987 0.1%
 
12/6/2011 12:00:00 AM 965 0.1%
 
2/14/2012 12:00:00 AM 933 0.1%
 
1/4/2016 12:00:00 AM 923 0.1%
 
9/3/2013 12:00:00 AM 920 0.1%
 
1/3/2017 12:00:00 AM 882 0.1%
 
11/6/2018 12:00:00 AM 864 0.1%
 
7/30/2013 12:00:00 AM 837 0.1%
 
Other values (2462) 767702 84.9%
 
(Missing) 127086 14.0%
 
Max length22
Mean length18.42302527
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

ARREST_DATE
Categorical

Distinct count269479
Unique (%)29.8%
Missing (%)3.4%
Missing (n)30683
5/18/2016 8:15:00 PM
 
668
3/28/2017 8:20:00 AM
 
495
5/19/2016 2:40:00 AM
 
493
Other values (269475)
872380
(Missing)
 
30683
ValueCountFrequency (%) 
5/18/2016 8:15:00 PM 668 0.1%
 
3/28/2017 8:20:00 AM 495 0.1%
 
5/19/2016 2:40:00 AM 493 0.1%
 
12/22/2014 10:49:00 AM 422 < 0.1%
 
9/28/2018 3:14:00 PM 370 < 0.1%
 
8/20/2014 9:33:00 AM 354 < 0.1%
 
2/26/2011 5:35:00 PM 342 < 0.1%
 
3/10/2012 1:49:00 AM 326 < 0.1%
 
3/1/2013 11:55:00 AM 294 < 0.1%
 
1/25/2012 10:40:00 AM 287 < 0.1%
 
Other values (269468) 869985 96.2%
 
(Missing) 30683 3.4%
 
Max length22
Mean length19.66057417
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

CASE_ID
Numeric

Distinct count310135
Unique (%)34.3%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean1.22620192e+11
Minimum6.499985167e+10
Maximum1.312340918e+11
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum6.499985167e+10
5-th percentile1.15026065e+11
Q11.183591503e+11
Median1.227271446e+11
Q31.268397286e+11
95-th percentile1.301468348e+11
Maximum1.312340918e+11
Range6.623424009e+10
Interquartile range8480578272

Descriptive statistics

Standard deviation4914641069
Coef of variation0.0400801939
Kurtosis1.109886342
Mean1.22620192e+11
MAD4237424801
Skewness-0.227589411
Sum1.109368175e+17
Variance2.415369684e+19
Memory size6.9 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[6.49998517e+10 6.58217771e+10 6.86539147e+10 1.14069912e+11 1.14078629e+11 ... 1.31177039e+11 1.31215607e+11 1.31228857e+11 1.31228945e+11 1.31234092e+11], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1.250925484e+11 1161 0.1%
 
1.158186255e+11 430 < 0.1%
 
1.224934163e+11 422 < 0.1%
 
1.261964064e+11 400 < 0.1%
 
1.260527791e+11 393 < 0.1%
 
1.207425129e+11 360 < 0.1%
 
1.218337121e+11 354 < 0.1%
 
1.244002554e+11 351 < 0.1%
 
1.144393396e+11 342 < 0.1%
 
1.194551677e+11 327 < 0.1%
 
Other values (310125) 900179 99.5%
 

Minimum 5 values

ValueCountFrequency (%) 
6.499985167e+10 105 < 0.1%
 
6.66437026e+10 8 < 0.1%
 
7.066412684e+10 2 < 0.1%
 
7.160552267e+10 1 < 0.1%
 
1.140682916e+11 8 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1.312340918e+11 2 < 0.1%
 
1.31234048e+11 1 < 0.1%
 
1.312339166e+11 1 < 0.1%
 
1.312337851e+11 1 < 0.1%
 
1.312337413e+11 1 < 0.1%
 

CASE_PARTICIPANT_ID
Highly correlated

This variable is highly correlated with CASE_ID and should be ignored for analysis

Correlation0.9997263254

CHAPTER
Categorical

Distinct count35
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
720
761365
625
 
125583
730
 
10465
Other values (32)
 
7306
ValueCountFrequency (%) 
720 761365 84.2%
 
625 125583 13.9%
 
730 10465 1.2%
 
15 2428 0.3%
 
430 2332 0.3%
 
35 995 0.1%
 
510 427 < 0.1%
 
815 426 < 0.1%
 
765 180 < 0.1%
 
305 146 < 0.1%
 
Other values (25) 372 < 0.1%
 
Max length20
Mean length2.996214294
Min length1
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

CHARGE_COUNT
Numeric

Distinct count668
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean6.426141155
Minimum1
Maximum668
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median2
Q36
95-th percentile21
Maximum668
Range667
Interquartile range5

Descriptive statistics

Standard deviation19.57786564
Coef of variation3.04659751
Kurtosis345.6398913
Mean6.426141155
MAD6.523871761
Skewness15.28861255
Sum5813852
Variance383.2928232
Memory size6.9 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 1. 1.5 2.5 3.5 4.5 ... 261.5 393.5 524.5 608.5 668. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1 326742 36.1%
 
2 143185 15.8%
 
3 85710 9.5%
 
4 67157 7.4%
 
5 49179 5.4%
 
6 41552 4.6%
 
7 29391 3.2%
 
8 24054 2.7%
 
9 18031 2.0%
 
10 14381 1.6%
 
Other values (658) 105337 11.6%
 

Minimum 5 values

ValueCountFrequency (%) 
1 326742 36.1%
 
2 143185 15.8%
 
3 85710 9.5%
 
4 67157 7.4%
 
5 49179 5.4%
 

Maximum 5 values

ValueCountFrequency (%) 
668 2 < 0.1%
 
667 2 < 0.1%
 
666 2 < 0.1%
 
665 2 < 0.1%
 
664 2 < 0.1%
 

CHARGE_ID
Highly correlated

This variable is highly correlated with CASE_PARTICIPANT_ID and should be ignored for analysis

Correlation0.9922534959

CHARGE_OFFENSE_TITLE
Categorical

Distinct count1402
Unique (%)0.2%
Missing (%)0.0%
Missing (n)0
AGGRAVATED UNLAWFUL USE OF WEAPON
 
114287
POSSESSION OF A CONTROLLED SUBSTANCE
 
97320
AGGRAVATED DRIVING UNDER THE INFLUENCE OF ALCOHOL
 
61779
Other values (1399)
631333
ValueCountFrequency (%) 
AGGRAVATED UNLAWFUL USE OF WEAPON 114287 12.6%
 
POSSESSION OF A CONTROLLED SUBSTANCE 97320 10.8%
 
AGGRAVATED DRIVING UNDER THE INFLUENCE OF ALCOHOL 61779 6.8%
 
AGGRAVATED BATTERY 57653 6.4%
 
FELONY DRIVING WHILE DRIVER?S LICENSE, PERMIT, OR PRIVILEGE TO OPERATE A MOTOR VEHICLE IS SUSPENDED OR REVOKED 43998 4.9%
 
UNLAWFUL USE OR POSSESSION OF A WEAPON BY A FELON 42372 4.7%
 
[POSSESSION OF CONTROLLED SUBSTANCE WITH INTENT TO DELIVER/DELIVERY OF A CONTROLLED SUBSTANCE] 37710 4.2%
 
FIRST DEGREE MURDER 30395 3.4%
 
RETAIL THEFT 23821 2.6%
 
[POSSESSION OF CONTROLLED SUBSTANCE WITH INTENT TO DELIVER/ DELIVERY OF A CONTROLLED SUBSTANCE] 21357 2.4%
 
Other values (1392) 374027 41.3%
 
Max length120
Mean length39.91095025
Min length5
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

CHARGE_VERSION_ID
Highly correlated

This variable is highly correlated with CHARGE_ID and should be ignored for analysis

Correlation0.9999812286

CLASS
Categorical

Distinct count13
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
4
359203
2
204485
3
137513
Other values (10)
203518
ValueCountFrequency (%) 
4 359203 39.7%
 
2 204485 22.6%
 
3 137513 15.2%
 
X 94734 10.5%
 
1 76322 8.4%
 
M 30394 3.4%
 
A 1586 0.2%
 
B 194 < 0.1%
 
C 119 < 0.1%
 
Z 92 < 0.1%
 
Other values (3) 77 < 0.1%
 
Max length1
Mean length1
Min length1
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

EVENT
Categorical

Distinct count6
Unique (%)< 0.1%
Missing (%)2.4%
Missing (n)21355
Preliminary Hearing
669029
Indictment
185598
Re-Indictment
 
16569
Other values (2)
 
12168
(Missing)
 
21355
ValueCountFrequency (%) 
Preliminary Hearing 669029 73.9%
 
Indictment 185598 20.5%
 
Re-Indictment 16569 1.8%
 
Direct Indictment 11983 1.3%
 
Grand Jury 185 < 0.1%
 
(Missing) 21355 2.4%
 
Max length19
Mean length16.63782235
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

EVENT_DATE
Categorical

Distinct count2577
Unique (%)0.3%
Missing (%)2.4%
Missing (n)21355
11/12/2019 12:00:00 AM
 
1501
1/20/2015 12:00:00 AM
 
985
7/12/2011 12:00:00 AM
 
903
Other values (2573)
879975
(Missing)
 
21355
ValueCountFrequency (%) 
11/12/2019 12:00:00 AM 1501 0.2%
 
1/20/2015 12:00:00 AM 985 0.1%
 
7/12/2011 12:00:00 AM 903 0.1%
 
2/3/2017 12:00:00 AM 880 0.1%
 
8/28/2013 12:00:00 AM 877 0.1%
 
9/17/2014 12:00:00 AM 876 0.1%
 
11/19/2015 12:00:00 AM 855 0.1%
 
11/15/2011 12:00:00 AM 852 0.1%
 
12/1/2014 12:00:00 AM 835 0.1%
 
4/25/2017 12:00:00 AM 818 0.1%
 
Other values (2566) 873982 96.6%
 
(Missing) 21355 2.4%
 
Max length22
Mean length20.53441787
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

GENDER
Categorical

Distinct count6
Unique (%)< 0.1%
Missing (%)0.5%
Missing (n)4180
Male
803244
Female
 
97258
Unknown Gender
 
20
Other values (2)
 
17
(Missing)
 
4180
ValueCountFrequency (%) 
Male 803244 88.8%
 
Female 97258 10.8%
 
Unknown Gender 20 < 0.1%
 
Male name, no gender given 10 < 0.1%
 
Unknown 7 < 0.1%
 
(Missing) 4180 0.5%
 
Max length26
Mean length4.210868789
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

INCIDENT_BEGIN_DATE
Categorical

Distinct count4505
Unique (%)0.5%
Missing (%)1.3%
Missing (n)11553
2/2/2016 12:00:00 AM
 
1347
12/17/2016 12:00:00 AM
 
988
1/1/2012 12:00:00 AM
 
929
Other values (4501)
889902
(Missing)
 
11553
ValueCountFrequency (%) 
2/2/2016 12:00:00 AM 1347 0.1%
 
12/17/2016 12:00:00 AM 988 0.1%
 
1/1/2012 12:00:00 AM 929 0.1%
 
10/19/2013 12:00:00 AM 918 0.1%
 
7/17/2017 12:00:00 AM 852 0.1%
 
1/1/2013 12:00:00 AM 843 0.1%
 
9/29/2015 12:00:00 AM 823 0.1%
 
11/5/2011 12:00:00 AM 737 0.1%
 
1/1/2011 12:00:00 AM 694 0.1%
 
2/11/2012 12:00:00 AM 670 0.1%
 
Other values (4494) 884365 97.8%
 
(Missing) 11553 1.3%
 
Max length22
Mean length20.69319866
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

INCIDENT_CITY
Categorical

Distinct count273
Unique (%)< 0.1%
Missing (%)3.9%
Missing (n)34905
Chicago
614613
Cicero
 
13221
Harvey
 
9787
Other values (269)
232193
(Missing)
 
34905
ValueCountFrequency (%) 
Chicago 614613 67.9%
 
Cicero 13221 1.5%
 
Harvey 9787 1.1%
 
Chicago Heights 7680 0.8%
 
Calumet City 7630 0.8%
 
Berwyn 6608 0.7%
 
Dolton 6209 0.7%
 
Orland Park 5779 0.6%
 
Oak Lawn 5561 0.6%
 
Evanston 5270 0.6%
 
Other values (262) 187456 20.7%
 
(Missing) 34905 3.9%
 
Max length21
Mean length7.60697852
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

INCIDENT_END_DATE
Categorical

Distinct count3792
Unique (%)0.4%
Missing (%)89.1%
Missing (n)806298
8/22/2011 12:00:00 AM
 
590
2/28/2013 12:00:00 AM
 
462
1/19/2017 12:00:00 AM
 
408
Other values (3788)
 
96961
(Missing)
806298
ValueCountFrequency (%) 
8/22/2011 12:00:00 AM 590 0.1%
 
2/28/2013 12:00:00 AM 462 0.1%
 
1/19/2017 12:00:00 AM 408 < 0.1%
 
9/30/2015 12:00:00 AM 345 < 0.1%
 
9/11/2011 12:00:00 AM 335 < 0.1%
 
10/31/2014 12:00:00 AM 327 < 0.1%
 
1/31/2007 12:00:00 AM 287 < 0.1%
 
7/23/2014 12:00:00 AM 275 < 0.1%
 
2/10/2016 12:00:00 AM 256 < 0.1%
 
6/30/2011 12:00:00 AM 254 < 0.1%
 
Other values (3781) 94882 10.5%
 
(Missing) 806298 89.1%
 
Max length22
Mean length4.954424523
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

LAW_ENFORCEMENT_AGENCY
Categorical

Distinct count303
Unique (%)< 0.1%
Missing (%)0.4%
Missing (n)3712
CHICAGO PD
604604
COOK COUNTY SHERIFF (IL0160000)
 
24233
CICERO PD
 
13601
Other values (299)
258569
ValueCountFrequency (%) 
CHICAGO PD 604604 66.8%
 
COOK COUNTY SHERIFF (IL0160000) 24233 2.7%
 
CICERO PD 13601 1.5%
 
HARVEY PD 8478 0.9%
 
CHICAGO HEIGHTS PD 7906 0.9%
 
CALUMET CITY PD 7249 0.8%
 
ISP DISTRICT CHICAGO 6600 0.7%
 
BERWYN PD 6588 0.7%
 
ORLAND PARK PD 6580 0.7%
 
DOLTON PD 5777 0.6%
 
Other values (292) 209391 23.1%
 
Max length60
Mean length11.87566416
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

OFFENSE_CATEGORY
Categorical

Distinct count87
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Narcotics
190542
UUW - Unlawful Use of Weapon
166621
Aggravated DUI
 
56761
Other values (84)
490795
ValueCountFrequency (%) 
Narcotics 190542 21.1%
 
UUW - Unlawful Use of Weapon 166621 18.4%
 
Aggravated DUI 56761 6.3%
 
Sex Crimes 47812 5.3%
 
Homicide 43345 4.8%
 
Driving With Suspended Or Revoked License 35736 3.9%
 
Armed Robbery 29725 3.3%
 
Aggravated Battery Police Officer 26920 3.0%
 
Retail Theft 24302 2.7%
 
Aggravated Battery 20299 2.2%
 
Other values (77) 262656 29.0%
 
Max length45
Mean length17.27411495
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

PRIMARY_CHARGE
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
False
577977
True
326742
ValueCountFrequency (%) 
False 577977 63.9%
 
True 326742 36.1%
 

RACE
Categorical

Distinct count13
Unique (%)< 0.1%
Missing (%)0.6%
Missing (n)5791
Black
601981
White [Hispanic or Latino]
156302
White
 
116238
Other values (9)
 
24407
ValueCountFrequency (%) 
Black 601981 66.5%
 
White [Hispanic or Latino] 156302 17.3%
 
White 116238 12.8%
 
HISPANIC 11126 1.2%
 
Asian 6492 0.7%
 
White/Black [Hispanic or Latino] 4692 0.5%
 
Unknown 1549 0.2%
 
American Indian 429 < 0.1%
 
Biracial 111 < 0.1%
 
ASIAN 6 < 0.1%
 
Other values (2) 2 < 0.1%
 
(Missing) 5791 0.6%
 
Max length32
Mean length8.800680653
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

RECEIVED_DATE
Categorical

Distinct count3258
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
5/19/2016 12:00:00 AM
 
1499
10/21/2013 12:00:00 AM
 
995
12/17/2016 12:00:00 AM
 
918
Other values (3255)
901307
ValueCountFrequency (%) 
5/19/2016 12:00:00 AM 1499 0.2%
 
10/21/2013 12:00:00 AM 995 0.1%
 
12/17/2016 12:00:00 AM 918 0.1%
 
10/22/2015 12:00:00 AM 905 0.1%
 
10/18/2011 12:00:00 AM 904 0.1%
 
8/27/2018 12:00:00 AM 808 0.1%
 
8/23/2011 12:00:00 AM 775 0.1%
 
1/25/2012 12:00:00 AM 759 0.1%
 
9/24/2013 12:00:00 AM 735 0.1%
 
12/23/2014 12:00:00 AM 722 0.1%
 
Other values (3248) 895699 99.0%
 
Max length22
Mean length20.93898658
Min length20
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

SECTION
Categorical

Distinct count1392
Unique (%)0.2%
Missing (%)< 0.1%
Missing (n)8
402(c)
 
94894
24-1.6(a)(1)
 
88050
11-501(a)
 
61943
Other values (1388)
659824
ValueCountFrequency (%) 
402(c) 94894 10.5%
 
24-1.6(a)(1) 88050 9.7%
 
11-501(a) 61943 6.8%
 
6-303(a) 46530 5.1%
 
24-1.1(a) 42372 4.7%
 
24-1.6(a)(2) 37662 4.2%
 
12-3.05(d)(4) 23692 2.6%
 
401(d)(i) 20608 2.3%
 
16-25(a)(1) 19346 2.1%
 
8-4(a)(720-5/9-1(a)(1)) 16925 1.9%
 
Other values (1381) 452689 50.0%
 
Max length30
Mean length9.813814013
Min length1
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

UNIT
Categorical

Distinct count98
Unique (%)< 0.1%
Missing (%)70.1%
Missing (n)633918
District 11 - Harrison
 
51987
District 10 - Ogden
 
21797
District 15 - Austin
 
18829
Other values (94)
178188
(Missing)
633918
ValueCountFrequency (%) 
District 11 - Harrison 51987 5.7%
 
District 10 - Ogden 21797 2.4%
 
District 15 - Austin 18829 2.1%
 
District 7 - Englewood 18240 2.0%
 
District 6 - Gresham 15448 1.7%
 
District 25 - Grand Central 14441 1.6%
 
District 5 - Calumet 12603 1.4%
 
District 9 - Deering 12433 1.4%
 
District 8 - Chicago Lawn 12088 1.3%
 
District 4 - South Chicago 11640 1.3%
 
Other values (87) 81295 9.0%
 
(Missing) 633918 70.1%
 
Max length57
Mean length8.981180897
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

UPDATED_OFFENSE_CATEGORY
Categorical

Distinct count81
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Narcotics
198825
UUW - Unlawful Use of Weapon
171125
Aggravated DUI
 
70872
Other values (78)
463897
ValueCountFrequency (%) 
Narcotics 198825 22.0%
 
UUW - Unlawful Use of Weapon 171125 18.9%
 
Aggravated DUI 70872 7.8%
 
Sex Crimes 48287 5.3%
 
Homicide 43668 4.8%
 
Aggravated Battery With A Firearm 36900 4.1%
 
Driving With Suspended Or Revoked License 36263 4.0%
 
Armed Robbery 30529 3.4%
 
Aggravated Battery Police Officer 28874 3.2%
 
Theft 24546 2.7%
 
Other values (71) 214830 23.7%
 
Max length45
Mean length17.76765382
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

Correlations

Missing values

Sample

First rows

ACTAGE_AT_INCIDENTAOICARRAIGNMENT_DATEARREST_DATECASE_IDCASE_PARTICIPANT_IDCHAPTERCHARGE_COUNTCHARGE_IDCHARGE_OFFENSE_TITLECHARGE_VERSION_IDCLASSEVENTEVENT_DATEGENDERINCIDENT_BEGIN_DATEINCIDENT_CITYINCIDENT_END_DATELAW_ENFORCEMENT_AGENCYOFFENSE_CATEGORYPRIMARY_CHARGERACERECEIVED_DATESECTIONUNITUPDATED_OFFENSE_CATEGORY
0522.007351007/11/2011 12:00:00 AM5/22/2011 6:51:00 PM6499985167126012225382372022037067609997FIRST DEGREE MURDER462725085037MPreliminary Hearing6/20/2011 12:00:00 AMMale3/12/2007 12:00:00 AMNaNNaNPROMIS Data ConversionPROMIS ConversionFalseBlack5/24/2011 12:00:00 AM9-1(a)(2)NaNHomicide
1522.007352007/11/2011 12:00:00 AM5/22/2011 6:51:00 PM6499985167126012225382372032037073820980FIRST DEGREE MURDER462726494735MPreliminary Hearing6/20/2011 12:00:00 AMMale3/12/2007 12:00:00 AMNaNNaNPROMIS Data ConversionPROMIS ConversionFalseBlack5/24/2011 12:00:00 AM9-1(a)(3)NaNHomicide
2522.007352007/11/2011 12:00:00 AM5/22/2011 6:51:00 PM6499985167126012225382372042037079144680FIRST DEGREE MURDER462727770177MPreliminary Hearing6/20/2011 12:00:00 AMMale3/12/2007 12:00:00 AMNaNNaNPROMIS Data ConversionPROMIS ConversionFalseBlack5/24/2011 12:00:00 AM9-1(a)(3)NaNHomicide
3522.007352007/11/2011 12:00:00 AM5/22/2011 6:51:00 PM6499985167126012225382372052037080919246FIRST DEGREE MURDER462728172948MPreliminary Hearing6/20/2011 12:00:00 AMMale3/12/2007 12:00:00 AMNaNNaNPROMIS Data ConversionPROMIS ConversionFalseBlack5/24/2011 12:00:00 AM9-1(a)(3)NaNHomicide
4522.007352007/11/2011 12:00:00 AM5/22/2011 6:51:00 PM6499985167126012225382372062037084172619FIRST DEGREE MURDER462728911361MPreliminary Hearing6/20/2011 12:00:00 AMMale3/12/2007 12:00:00 AMNaNNaNPROMIS Data ConversionPROMIS ConversionFalseBlack5/24/2011 12:00:00 AM9-1(a)(3)NaNHomicide
5522.007352007/11/2011 12:00:00 AM5/22/2011 6:51:00 PM6499985167126012225382372072037085059902FIRST DEGREE MURDER462729112747MPreliminary Hearing6/20/2011 12:00:00 AMMale3/12/2007 12:00:00 AMNaNNaNPROMIS Data ConversionPROMIS ConversionFalseBlack5/24/2011 12:00:00 AM9-1(a)(3)NaNHomicide
6522.007352007/11/2011 12:00:00 AM5/22/2011 6:51:00 PM6499985167126012225382372082037086242946FIRST DEGREE MURDER462729381261MPreliminary Hearing6/20/2011 12:00:00 AMMale3/12/2007 12:00:00 AMNaNNaNPROMIS Data ConversionPROMIS ConversionFalseBlack5/24/2011 12:00:00 AM9-1(a)(3)NaNHomicide
7522.007352007/11/2011 12:00:00 AM5/22/2011 6:51:00 PM6499985167126012225382372092037087425991FIRST DEGREE MURDER462729649775MPreliminary Hearing6/20/2011 12:00:00 AMMale3/12/2007 12:00:00 AMNaNNaNPROMIS Data ConversionPROMIS ConversionFalseBlack5/24/2011 12:00:00 AM9-1(a)(3)NaNHomicide
8522.007352007/11/2011 12:00:00 AM5/22/2011 6:51:00 PM64999851671260122253823720102037088313274FIRST DEGREE MURDER462729851160MPreliminary Hearing6/20/2011 12:00:00 AMMale3/12/2007 12:00:00 AMNaNNaNPROMIS Data ConversionPROMIS ConversionFalseBlack5/24/2011 12:00:00 AM9-1(a)(3)NaNHomicide
9522.007352007/11/2011 12:00:00 AM5/22/2011 6:51:00 PM64999851671260122253823720112037089200557FIRST DEGREE MURDER462730052545MPreliminary Hearing6/20/2011 12:00:00 AMMale3/12/2007 12:00:00 AMNaNNaNPROMIS Data ConversionPROMIS ConversionFalseBlack5/24/2011 12:00:00 AM9-1(a)(3)NaNHomicide

Last rows

ACTAGE_AT_INCIDENTAOICARRAIGNMENT_DATEARREST_DATECASE_IDCASE_PARTICIPANT_IDCHAPTERCHARGE_COUNTCHARGE_IDCHARGE_OFFENSE_TITLECHARGE_VERSION_IDCLASSEVENTEVENT_DATEGENDERINCIDENT_BEGIN_DATEINCIDENT_CITYINCIDENT_END_DATELAW_ENFORCEMENT_AGENCYOFFENSE_CATEGORYPRIMARY_CHARGERACERECEIVED_DATESECTIONUNITUPDATED_OFFENSE_CATEGORY
904709528.00012474NaN12/1/2019 3:49:00 PM131233522335110154242311672022585370245907AGGRAVATED UNLAWFUL USE OF WEAPON5896417023154NaNNaNMale12/1/2019 12:00:00 AMBroadviewNaNBROADVIEW PDUUW - Unlawful Use of WeaponFalseBlack12/1/2019 12:00:00 AM24-1.6(a)(1)NaNUUW - Unlawful Use of Weapon
904710528.00012474NaN12/1/2019 3:49:00 PM131233522335110154242311672012585369950146AGGRAVATED UNLAWFUL USE OF WEAPON5896416351874NaNNaNMale12/1/2019 12:00:00 AMBroadviewNaNBROADVIEW PDUUW - Unlawful Use of WeaponTrueBlack12/1/2019 12:00:00 AM24-1.6(a)(1)NaNUUW - Unlawful Use of Weapon
904711527.00012475NaN12/1/2019 11:35:00 AM131233609939110154324392172012585370541668AGGRAVATED UNLAWFUL USE OF WEAPON5896417694442NaNNaNMale12/1/2019 12:00:00 AMChicagoNaNCHICAGO PDUUW - Unlawful Use of WeaponTrueBlack12/1/2019 12:00:00 AM24-1.6(a)(1)NaNUUW - Unlawful Use of Weapon
904712544.00013855NaN12/1/2019 6:55:00 PM131233697543110154441650172012585370837429ARMED HABITUAL CRIMINAL589641836572XNaNNaNMale12/1/2019 12:00:00 AMChicagoNaNCHICAGO PDUUW - Unlawful Use of WeaponTrueBlack12/1/2019 12:00:00 AM24-1.7(a)NaNUUW - Unlawful Use of Weapon
904713532.00017862NaN12/1/2019 5:59:00 PM131233741345110154500279172012585371133190AGGRAVATED UNLAWFUL USE OF WEAPON5896419037014NaNNaNMale12/1/2019 12:00:00 AMChicagoNaNCHICAGO PDUUW - Unlawful Use of WeaponTrueHISPANIC12/1/2019 12:00:00 AM24-1.6(a)(1)NaNUUW - Unlawful Use of Weapon
904714529.01214500NaN12/1/2019 8:18:00 PM131233785148110154535456572012585371428951UNLAWFUL USE OR POSSESSION OF A WEAPON BY A FELON5896419708293NaNNaNMale12/1/2019 12:00:00 AMChicagoNaNCHICAGO PDUUW - Unlawful Use of WeaponTrueBlack12/1/2019 12:00:00 AM24-1.1(a)NaNUUW - Unlawful Use of Weapon
904715525.00015296NaN12/1/2019 6:50:00 PM131233916554110154687891872012585371724712BOARD AIRCRAFT WITH WEAPON5896420379584NaNNaNMale12/1/2019 12:00:00 AMChicagoNaNCHICAGO PDUUW - Unlawful Use of WeaponTrueWhite12/1/2019 12:00:00 AM29D-35.1(a)NaNUUW - Unlawful Use of Weapon
904716519.01100000NaN12/1/2019 9:37:00 PM131234047960110154887230472012585372020473ROBBERY5896421050862NaNNaNMale12/1/2019 12:00:00 AMChicagoNaNCHICAGO PDRobberyTrueBlack12/2/2019 12:00:00 AM18-1(a)NaNRobbery
904717521.01115000NaN12/1/2019 11:25:00 PM131234091763110154957585172022585372611996POSSESSION OF BURGLARY TOOLS5896422393434NaNNaNMale12/1/2019 12:00:00 AMHoffman EstatesNaNHOFFMAN ESTATES PDBurglaryFalseWhite12/2/2019 12:00:00 AM19-2(a)NaNBurglary
904718521.01110000NaN12/1/2019 11:25:00 PM131234091763110154957585172012585372316235ATTEMPT BURGLARY5896421722153NaNNaNMale12/1/2019 12:00:00 AMHoffman EstatesNaNHOFFMAN ESTATES PDBurglaryTrueWhite12/2/2019 12:00:00 AM8-4(19-1(a))NaNBurglary